Steps to Geocode in Awesome table

  1. Upload and open in or copy the contents of “ua_populations.csv” in Google Sheets

STEP 1

  1. Filter the sheet to only show 2011 data so that we end up with a single entry for each UA

STEP 2a STEP 2b

  1. Copy the first 2 rows and paste into a new sheet.

  2. In new sheet, create a column called “country” and fill the first cell with “India”. Select all cells below it and fill them all with India too (Select all cells including first cell with India -> Ctrl/CMD + D)

STEP 4

  1. Find and replace all instances of “U.A” with blank space (Be careful to add the period otherwise names will get changed)

STEP 5

  1. Go to “Add-ons” in the menu bar -> “Get Add-Ons” -> Search for “Geocode by Awesome Table” and install it

STEP 6

  1. Once it installs, go to “Add-ons” in the menu bar -> “Geocode by Awesome Table” -> “Start Geocoding”

  2. Choose the “address in multiple columns option and choose”ua" and “country”, what this will do is create a new column "Full Address that will have the city and country concatenated.

STEP 8

  1. Make sure “Full address is your Address Column and click”Geocode!". This will create two columns, Latitude and Longitude that we will use.

STEP 9

  1. Please bear in mind this might not be very exact. One mistake it makes is Nanded-Waghala, UA number 91. We shall correct this manually for now - Latitude 19.1383, Longitude 77.321

STEP 10

  1. Download the current sheet as a “.csv” and move it to the data/spatial_data folder with the name “ua_geocode.csv”